-------------------------------------------------------------- 
-- 
--- inserts for reference for regions reference tables	------
-- 
--------------------------------------------------------------
USE [mt_trailers]
GO
/****** Object:  Table [dbo].[mtt_rating_location_ref]    Script Date: 06/12/2009 14:24:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[mtt_rating_location_ref](
	[rating_location_id] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
	[rating_location_region] [nvarchar](35) NULL,
	[rating_location_subregion] [nvarchar](35) NULL,
	[rating_state] [nvarchar](35) NULL,
	[rating_state_two_letters] [nvarchar](5) NULL
) ON [PRIMARY]

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('South', 'East South Central', 'Alabama', 'AL')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('South', 'East South Central', 'Mississippi', 'MS')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('South', 'East South Central', 'Tennessee', 'TN')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('South', 'East South Central', 'Kentucky', 'KY')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('South', 'South Atlantic', 'Florida', 'FL')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('South', 'South Atlantic', 'Georgia', 'GA')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('South', 'South Atlantic', 'South Carolina', 'SC')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('South', 'South Atlantic', 'North Carolina', 'NC')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('South', 'South Atlantic', 'Virginia', 'VA')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('South', 'South Atlantic', 'West Virginia', 'WV')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('South', 'South Atlantic', 'Maryland', 'MD')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('South', 'South Atlantic', 'Delaware', 'DE')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('Northeast', 'Middle Atlantic', 'Pennsylvania', 'PA')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('Northeast', 'Middle Atlantic', 'New York', 'NY')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('Northeast', 'Middle Atlantic', 'New Jersey', 'NJ')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('Northeast', 'New England', 'Connecticut', 'CT')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('Northeast', 'New England', 'Maine', 'ME')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('Northeast', 'New England', 'Vermont', 'VT')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('Northeast', 'New England', 'New Hampshire', 'NH')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('Northeast', 'New England', 'Massachusetts', 'MA')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('Northeast', 'New England', 'Rhode Island', 'RI')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('South', 'West South Central', 'Texas', 'TX')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('South', 'West South Central', 'Louisiana', 'LA')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('South', 'West South Central', 'Oklahoma', 'OK')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('South', 'West South Central', 'Arkansas', 'AR')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('West', 'Pacific', 'Alaska', 'AK')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('West', 'Pacific', 'Hawaii', 'HI')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('West', 'Pacific', 'California', 'CA')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('West', 'Pacific', 'Oregon', 'OR')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('West', 'Pacific', 'Washington', 'WA')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('West', 'Mountain', 'Arizona', 'AZ')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('West', 'Mountain', 'New Mexico', 'NM')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('West', 'Mountain', 'Colorado', 'CO')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('West', 'Mountain', 'Utah', 'UT')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('West', 'Mountain', 'Nevada', 'NV')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('West', 'Mountain', 'Wyoming', 'WY')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('West', 'Mountain', 'Idaho', 'ID')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('West', 'Mountain', 'Montana', 'MT')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('Midwest', 'West North Central', 'North Dakota', 'ND')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('Midwest', 'West North Central', 'South Dakota', 'SD')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('Midwest', 'West North Central', 'Nebraska', 'NE')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('Midwest', 'West North Central', 'Kansas', 'KS')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('Midwest', 'West North Central', 'Iowa', 'IA')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('Midwest', 'West North Central', 'Minnesota', 'MN')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('Midwest', 'West North Central', 'Missouri', 'MO')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('Midwest', 'East North Central', 'Wisconsin', 'WI')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('Midwest', 'East North Central', 'Indiana', 'IN')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('Midwest', 'East North Central', 'Ohio', 'OH')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('Midwest', 'East North Central', 'Michigan', 'MI')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('Midwest', 'East North Central', 'Illinois', 'IL')

INSERT INTO dbo.mtt_rating_location_ref
                      (rating_location_region, rating_location_subregion, rating_state, rating_state_two_letters)
VALUES     ('Midwest', 'East North Central', 'Illinois', 'IL')

















